﻿CREATE TABLE [dbo].[Bugs] (
    [BugPK]        UNIQUEIDENTIFIER NOT NULL,
    [BugID]        INT              IDENTITY (1, 1) NOT NULL,
    [Description]  NVARCHAR (MAX)   NOT NULL,
    [ProjectFK]    UNIQUEIDENTIFIER NOT NULL,
    [AssignedToFK] UNIQUEIDENTIFIER NULL,
    [StateFK]      UNIQUEIDENTIFIER NOT NULL,
    [DueDate]      DATETIME         NOT NULL,
    [CreatedDate]  DATETIME         NOT NULL,
    [CreatedBy]    UNIQUEIDENTIFIER NOT NULL
);

